[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
Combined Date and Time Representation
Any date component can be added to any time component to produce a serial value for that date/time combination.
[Example: For the 1900 date base system:
DATE(1910,2,3)+TIME(10,5,54) results in the serial value 3687.4207639…
DATE(1900,1,1)+TIME(12,0,0) results in the serial value 1.5000000…
DATE(9999,12,31)+TIME(23,59,59) results in the serial value 2958465.9999884…
For the 1904 date base system:
DATE(1910,2,3)+TIME(10,5,54) results in the serial value 2225.4207639…
DATE(1904,1,1)+TIME(12,0,0) results in the serial value 0.5000000…
DATE(9999,12,31)+TIME(23,59,59) results in the serial value 2957003.9999884…
end example]